USE [movie]
GO

/****** Object:  StoredProcedure [dbo].[mov_ValidateLogin]    Script Date: 05/21/2011 13:18:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'mov_ValidateLogin' AND type = 'P') DROP PROCEDURE mov_ValidateLogin
GO





-- =============================================
-- Author:		Sourov Chatterjee
-- Modified:    Pritam Bhat
-- Create date: 5/18/2011
-- Description:	This procedure checks if login info. exists
-- Modified Date: 
-- Modified   : 
-- Modified By: 

-- =============================================
CREATE PROCEDURE [dbo].[mov_ValidateLogin] 	
(
	@email varchar(40),
    @password varchar(10)
)
AS
BEGIN
	
	SET NOCOUNT ON;

-- Declare variables


SELECT  cus_email,cus_password
FROM customer 
WHERE cus_email 	= @email
AND cus_password =@password

END



GO


